Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

You have to log in to post to discussions.

Related terms

Windows 10
Software; Operating systems

Windows 10 is a personal computer operating system ...

Evernote
Software; Productivity software

Evernote is a simple glassware that makes taking notes easy ...

scan configuration file
Software; Globalization software service

A configuration that contains information for scanning ...

qt
Software; Software development

Qt is an open source software development framework ...

Spartan
Software; Web browser

Spartan is the new Microsoft web browser. The new ...

Groupon
Software; Phone apps

Redeem Groupon deals (as much as 50-90% off!) on everything ...

Creator

Featured blossaries

Sailing

Category: Entertainment   3 11 Terms

Parkour

Category: Sports   1 10 Terms

Trending

Category: Other   1 5 Terms

Starbucks Teas Beverages

Category: Food   2 29 Terms

Greatest WWE wrestlers

Category: Sports   3 10 Terms

The Hunger Games

Category: Entertainment   2 19 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Follow us on: